1 Description of DataSchema variable

The description of harmonised variables is the following:

  • Short name: cont_rel
  • Variable label: Are the contacts ( face-to-face/phone/mail/Internet communicators) with family members/relatives frequent (i.e. contact once a week or more often)?
  • Domain: Social environment
  • Value type: cathegorical
  • Categories:
Code Category Label
0 No
1 Yes
  • Category missings:
Code Category Label
991 CAPI/interviewer error
992 Impute
993 Disable to measure
994 Not attempt/not done
995 Does not answer
996 Not applicable
997 Refuse
998 Do not know
999 Missing

2 Data process

2.1 England

2.1.1 Wave 1

2.1.1.1 Study-specific variable description

The study-specific variables elected to be harmonised are:

  • Name: scchdg
  • Label: On average how often do you meet up with your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scfamg
  • Label: On average how often meet up with family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scchdh
  • Label: on average how often do you speak on the phone to your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scchdi
  • Label: on average how often do you write or email your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scfami
  • Label: on average how often do you write or email family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: dhr2 UP TO dhr13
  • Label: What is [your/member of household~s] relationship to [person 2]
  • Categories:
    • 1 = Husband/Wife
    • 2 = Partner/cohabitee
    • 3 = Natural son/daughter
    • 4 = Adopted son/daughter
    • 5 = Foster son/daughter
    • 6 = Step son/daughter/child of partner
    • 7 = Son/daughter-in-law
    • 8 = Natural parent
    • 9 = Adoptive parent
    • 10 = Foster parent
    • 11 = Stepparent/parent s partner
    • 12 = Parent-in-law
    • 13 = Natural brother/sister
    • 14 = Half-brother/sister
    • 15 = Step-brother/sister
    • 16 = Adopted brother/sister
    • 17 = Foster brother/sister
    • 18 = Brother/sister-in-law
    • 19 = Grandchild
    • 20 = Grandparent
    • 21 = Other relative
    • 22 = Other non-relative
    • 96 = Self (THIS CODE NOT USED)
  • Missings:
    • -9 = Refusal
    • -8 = Don't Know
    • -1 = Not applicable
  • Note: IF relationship os self: DHR=96, “Code 96 is not valid for this question”

  • Description:

SCCHDG
Sample size Missing values
12099 3507
Category
1 2 3 4 5 6
Frequency 2138.00 3093.00 1665.00 1170.00 324.00 202.00
Percentage 17.67 25.56 13.76 9.67 2.68 1.67
Type of missing
-1 -8 -9 NA
Frequency 2709.00 0 798.0 0
Percentage 22.39 0 6.6 0

SCFAMG
Sample size Missing values
12099 2633
Category
1 2 3 4 5 6
Frequency 1092.00 2288.00 1831.00 1952.00 1324.00 979.00
Percentage 9.03 18.91 15.13 16.13 10.94 8.09
Type of missing
-1 -8 -9 NA
Frequency 2312.00 0 321.00 0
Percentage 19.11 0 2.65 0

SCCHDH
Sample size Missing values
12099 3409
Category
1 2 3 4 5 6
Frequency 3756.00 3818.00 753.00 156.00 61.0 146.00
Percentage 31.04 31.56 6.22 1.29 0.5 1.21
Type of missing
-1 -8 -9 NA
Frequency 2709.00 0 700.00 0
Percentage 22.39 0 5.79 0

SCCHDI
Sample size Missing values
12099 5123
Category
1 2 3 4 5 6
Frequency 212.00 539.00 838.00 757.00 1038.00 3592.00
Percentage 1.75 4.45 6.93 6.26 8.58 29.69
Type of missing
-1 -8 -9 NA
Frequency 2709.00 0 2414.00 0
Percentage 22.39 0 19.95 0

SCFAMI
Sample size Missing values
12099 4427
Category
1 2 3 4 5 6
Frequency 78.00 249.00 608.00 911.00 1440.0 4386.00
Percentage 0.64 2.06 5.03 7.53 11.9 36.25
Type of missing
-1 -8 -9 NA
Frequency 2312.00 0 2115.00 0
Percentage 19.11 0 17.48 0

DHR2
Sample size Missing values
12099 7329
Category
1 2 3 6 7 8 9 10 11 12 13 15 17 18 20 21 22
Frequency 3979.00 236.00 35.00 3.00 1.00 376.00 4.00 2.00 7.00 15.00 29.00 1.00 1.00 5.00 12.0 11.00 53.00
Percentage 32.89 1.95 0.29 0.02 0.01 3.11 0.03 0.02 0.06 0.12 0.24 0.01 0.01 0.04 0.1 0.09 0.44
Type of missing
-1 -8 -9 96 NA
Frequency 2779.00 0 0 4550.00 0
Percentage 22.97 0 0 37.61 0

DHR3
Sample size Missing values
12099 9847
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 35.00 20.00 25.00 1.00 14.00 1865.00 33.00 12.0 69.00 23.00 13.00 5.00 70.00 13.00 54.00
Percentage 0.29 0.17 0.21 0.01 0.12 15.41 0.27 0.1 0.57 0.19 0.11 0.04 0.58 0.11 0.45
Type of missing
-1 -8 -9 96 NA
Frequency 9759.00 0 0 88.00 0
Percentage 80.66 0 0 0.73 0

DHR4
Sample size Missing values
12099 10869
Category
1 2 3 7 8 9 10 11 12 13 18 20 21 22
Frequency 13.00 6.00 10.00 7.00 992.0 18.00 10.00 26.00 12.0 6.00 3.00 83.00 11.00 33.00
Percentage 0.11 0.05 0.08 0.06 8.2 0.15 0.08 0.21 0.1 0.05 0.02 0.69 0.09 0.27
Type of missing
-1 -8 -9 96 NA
Frequency 10846.00 0 0 23.00 0
Percentage 89.64 0 0 0.19 0

DHR5
Sample size Missing values
12099 11704
Category
1 2 3 6 8 9 10 11 12 13 18 20 21 22
Frequency 3.00 2.00 1.00 1.00 279.00 2.00 4.00 12.0 10.00 4.00 2.00 51.00 4.00 20.00
Percentage 0.02 0.02 0.01 0.01 2.31 0.02 0.03 0.1 0.08 0.03 0.02 0.42 0.03 0.17
Type of missing
-1 -8 -9 96 NA
Frequency 11697.00 0 0 7.00 0
Percentage 96.68 0 0 0.06 0

DHR6
Sample size Missing values
12099 11979
Category
1 2 3 7 8 10 11 12 20 22
Frequency 1.00 1.00 2.00 1.00 75.00 2.00 2.00 5.00 20.00 11.00
Percentage 0.01 0.01 0.02 0.01 0.62 0.02 0.02 0.04 0.17 0.09
Type of missing
-1 -8 -9 96 NA
Frequency 11976.00 0 0 3.00 0
Percentage 98.98 0 0 0.02 0

DHR7
Sample size Missing values
12099 12058
Category
2 8 9 10 11 20 22
Frequency 1.00 19.00 1.00 2.00 2.00 13.00 3.00
Percentage 0.01 0.16 0.01 0.02 0.02 0.11 0.02
Type of missing
-1 -8 -9 96 NA
Frequency 12057.00 0 0 1.00 0
Percentage 99.65 0 0 0.01 0

DHR8
Sample size Missing values
12099 12085
Category
8 11 20 22
Frequency 11.00 1.00 1.00 1.00
Percentage 0.09 0.01 0.01 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 12085.00 0 0 0 0
Percentage 99.88 0 0 0 0

DHR9
Sample size Missing values
12099 12092
Category
8 20
Frequency 4.00 3.00
Percentage 0.03 0.02
Type of missing
-1 -8 -9 96 NA
Frequency 12092.00 0 0 0 0
Percentage 99.94 0 0 0 0

DHR10
Sample size Missing values
12099 12096
Category
8 20
Frequency 2.00 1.00
Percentage 0.02 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 12096.00 0 0 0 0
Percentage 99.98 0 0 0 0

DHR11
Sample size Missing values
12099 12096
Category
20 22
Frequency 2.00 1.00
Percentage 0.02 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 12096.00 0 0 0 0
Percentage 99.98 0 0 0 0

DHR12
Sample size Missing values
12099 12098
Category
22
Frequency 1.00
Percentage 0.01
Type of missing
-1 -8 -9 NA
Frequency 12098.00 0 0 0
Percentage 99.99 0 0 0

DHR13
Sample size Missing values
12099 12098
Category
22
Frequency 1.00
Percentage 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 12098.00 0 0 0 0
Percentage 99.99 0 0 0 0

2.1.1.2 Harmonisation algorithm

To compute the harmonize variable from the study-specific variable it has to be recoded as follows:

  • scchdg OR scfamg in {1,2,3} OR scchdh OR scchdi OR scfami in {1,2} OR any of dhr2,..,dhr13 in 1:21 into 1
  • scchdg AND scfamg in {4,5,6} AND scchdh AND scchdi AND scfami in {3,4,5,6} AND all dhr2,..,dhr13 not in 1:21 into 0
  • scchdg AND scfamg AND scchdh AND scchdi AND scfami in (-9,NA) AND dhr2 AND,..., AND dhr13 in (-8,-9,96,NA) into 999
  • scchdg AND scfamg AND scchdh AND scchdi AND scfami AND dhr2 AND,.., AND dhr13 = -1 into 996

R script:

ELSA_ds_w1 <- tibble(id = ELSA_w1_cont_rel$id)

ELSA_w1_cont_rel$scchdg <- car::recode(as.vector(ELSA_w1_cont_rel$scchdg), "NA='-999'")
ELSA_w1_cont_rel$scfamg <- car::recode(as.vector(ELSA_w1_cont_rel$scfamg), "NA='-999'")
ELSA_w1_cont_rel$scchdh <- car::recode(as.vector(ELSA_w1_cont_rel$scchdh), "NA='-999'")
ELSA_w1_cont_rel$scchdi <- car::recode(as.vector(ELSA_w1_cont_rel$scchdi), "NA='-999'")
ELSA_w1_cont_rel$scfami <- car::recode(as.vector(ELSA_w1_cont_rel$scfami), "NA='-999'")
ELSA_w1_cont_rel$dhr2 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr2), "NA='-999'")
ELSA_w1_cont_rel$dhr3 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr3), "NA='-999'")
ELSA_w1_cont_rel$dhr4 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr4), "NA='-999'")
ELSA_w1_cont_rel$dhr5 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr5), "NA='-999'")
ELSA_w1_cont_rel$dhr6 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr6), "NA='-999'")
ELSA_w1_cont_rel$dhr7 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr7), "NA='-999'")
ELSA_w1_cont_rel$dhr8 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr8), "NA='-999'")
ELSA_w1_cont_rel$dhr9 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr9), "NA='-999'")
ELSA_w1_cont_rel$dhr10 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr10), "NA='-999'")
ELSA_w1_cont_rel$dhr11 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr11), "NA='-999'")
ELSA_w1_cont_rel$dhr12 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr12), "NA='-999'")
ELSA_w1_cont_rel$dhr13 <- car::recode(as.vector(ELSA_w1_cont_rel$dhr13), "NA='-999'")

ELSA_ds_w1$cont_rel <- c(NA)
for (i in 1:dim(ELSA_w1_cont_rel)[1]) {
    if (ELSA_w1_cont_rel$scchdg[i] %in% c(1, 2, 3) | ELSA_w1_cont_rel$scfamg[i] %in% 
        c(1, 2, 3) | ELSA_w1_cont_rel$scchdh[i] %in% c(1, 2) | ELSA_w1_cont_rel$scchdi[i] %in% 
        c(1, 2) | ELSA_w1_cont_rel$scfami[i] %in% c(1, 2) | ELSA_w1_cont_rel$dhr2[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr3[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr4[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr5[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr6[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr7[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr8[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr9[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr10[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr11[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr12[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr13[i] %in% c(1:21)) {
        ELSA_ds_w1$cont_rel[i] = 1
    } else if (ELSA_w1_cont_rel$scchdg[i] %in% c(-9, -999) & ELSA_w1_cont_rel$scfamg[i] %in% 
        c(-9, -999) & ELSA_w1_cont_rel$scchdh[i] %in% c(-9, -999) & ELSA_w1_cont_rel$scchdi[i] %in% 
        c(-9, -999) & ELSA_w1_cont_rel$scfami[i] %in% c(-9, -999) & ELSA_w1_cont_rel$dhr2[i] %in% 
        c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr3[i] %in% c(96, -8, -9, -999) & 
        ELSA_w1_cont_rel$dhr4[i] %in% c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr5[i] %in% 
        c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr6[i] %in% c(96, -8, -9, -999) & 
        ELSA_w1_cont_rel$dhr7[i] %in% c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr8[i] %in% 
        c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr9[i] %in% c(96, -8, -9, -999) & 
        ELSA_w1_cont_rel$dhr10[i] %in% c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr11[i] %in% 
        c(96, -8, -9, -999) & ELSA_w1_cont_rel$dhr12[i] %in% c(96, -8, -9, -999) & 
        ELSA_w1_cont_rel$dhr13[i] %in% c(96, -8, -9, -999)) {
        ELSA_ds_w1$cont_rel[i] = 999
    } else if (ELSA_w1_cont_rel$scchdg[i] == -1 & ELSA_w1_cont_rel$scfamg[i] == 
        -1 & ELSA_w1_cont_rel$scchdh[i] == -1 & ELSA_w1_cont_rel$scchdi[i] == 
        -1 & ELSA_w1_cont_rel$scfami[i] == -1 & ELSA_w1_cont_rel$dhr2[i] == 
        -1 & ELSA_w1_cont_rel$dhr3[i] == -1 & ELSA_w1_cont_rel$dhr4[i] == -1 & 
        ELSA_w1_cont_rel$dhr5[i] == -1 & ELSA_w1_cont_rel$dhr6[i] == -1 & ELSA_w1_cont_rel$dhr7[i] == 
        -1 & ELSA_w1_cont_rel$dhr8[i] == -1 & ELSA_w1_cont_rel$dhr9[i] == -1 & 
        ELSA_w1_cont_rel$dhr10[i] == -1 & ELSA_w1_cont_rel$dhr11[i] == -1 & 
        ELSA_w1_cont_rel$dhr12[i] == -1 & ELSA_w1_cont_rel$dhr13[i] == -1) {
        ELSA_ds_w1$cont_rel[i] = 996
    } else if (ELSA_w1_cont_rel$scchdg[i] %in% c(4, 5, 6) & ELSA_w1_cont_rel$scfamg[i] %in% 
        c(4, 5, 6) & ELSA_w1_cont_rel$scchdh[i] %in% c(3, 4, 5, 6) & ELSA_w1_cont_rel$scchdi[i] %in% 
        c(3, 4, 5, 6) & ELSA_w1_cont_rel$scfami[i] %in% c(3, 4, 5, 6) & !(ELSA_w1_cont_rel$dhr2[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr3[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr4[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr5[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr6[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr7[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr8[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr9[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr10[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr11[i] %in% c(1:21) | ELSA_w1_cont_rel$dhr12[i] %in% 
        c(1:21) | ELSA_w1_cont_rel$dhr13[i] %in% c(1:21))) {
        ELSA_ds_w1$cont_rel[i] = 0
    }
}



ELSA_ds_w1$cont_rel <- car::recode(as.vector(ELSA_ds_w1$cont_rel), "NA='999'")
ELSA_ds_w1$cont_rel <- labelled(ELSA_ds_w1$cont_rel, labels = c(No = 0, Yes = 1, 
    Missing = 999, `Do not know` = 998, Refuse = 997, `Not applicable` = 996, 
    `Don't answer` = 995, `Not attempt/not done/not yet recorded` = 994, `Disable to measure` = 993, 
    Impute = 992, `CAPI/interviewer error` = 991))

2.1.1.3 Statistical description of the new harmonised variable

Sample size Missing values
12099 1362
Category
0 1
Frequency 135.00 10602.00
Percentage 1.12 87.63
Type of missing
991 992 993 994 995 996 997 998 999 NA
Frequency 0 0 0 0 0 480.00 0 0 882.00 0
Percentage 0 0 0 0 0 3.97 0 0 7.29 0

2.1.1.4 Validation

2.1.2 Wave 2

2.1.2.1 Study-specific variable description

The study-specific variable elected to be harmonised is:

  • Name: scchdg
  • Label: On average how often do you meet up with your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scfamg
  • Label: On average how often meet up with family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scchdh
  • Label: on average how often do you speak on the phone to your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scchdi
  • Label: on average how often do you write or email your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scfamh
  • Label: How often the respondent speaks with other relatives on the phone
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: scfami
  • Label: on average how often do you write or email family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -1 = Item not applicable
  • Name: DhR12 UP TO DhR12
  • Label: Relationship of this person to Person 2 in the household
  • Categories:
    • 1 = Husband/Wife
    • 2 = Partner/cohabitee
    • 3 = Natural son/daughter
    • 4 = Adopted son/daughter
    • 5 = Foster son/daughter
    • 6 = Step son/daughter/child of partner
    • 7 = Son/daughter-in-law
    • 8 = Natural parent
    • 9 = Adoptive parent
    • 10 = Foster parent
    • 11 = Stepparent/parent s partner
    • 12 = Parent-in-law
    • 13 = Natural brother/sister
    • 14 = Half-brother/sister
    • 15 = Step-brother/sister
    • 16 = Adopted brother/sister
    • 17 = Foster brother/sister
    • 18 = Brother/sister-in-law
    • 19 = Grandchild
    • 20 = Grandparent
    • 21 = Other relative
    • 22 = Other non-relative
    • 96 = (THIS CODE NOT USED)
  • Missings:
    • -9 = Refusal
    • -8 = Don't Know
    • -1 = Not applicable
  • Description:
SCCHDG
Sample size Missing values
9432 2739
Category
1 2 3 4 5 6
Frequency 1501.00 2360.00 1408.00 999.00 262.00 163.00
Percentage 15.91 25.02 14.93 10.59 2.78 1.73
Type of missing
-1 -8 -9 NA
Frequency 2295.00 0 444.00 0
Percentage 24.33 0 4.71 0

SCFAMG
Sample size Missing values
9432 2050
Category
1 2 3 4 5 6
Frequency 782.00 1728.00 1448.00 1620.00 1025.00 779.00
Percentage 8.29 18.32 15.35 17.18 10.87 8.26
Type of missing
-1 -8 -9 NA
Frequency 1791.00 0 259.00 0
Percentage 18.99 0 2.75 0

SCCHDH
Sample size Missing values
9432 2680
Category
1 2 3 4 5 6
Frequency 2935.00 2921.00 627.00 123.0 44.00 102.00
Percentage 31.12 30.97 6.65 1.3 0.47 1.08
Type of missing
-1 -8 -9 NA
Frequency 2295.00 0 385.00 0
Percentage 24.33 0 4.08 0

SCCHDI
Sample size Missing values
9432 3472
Category
1 2 3 4 5 6
Frequency 228.00 534.00 743.00 626.00 800.00 3029.00
Percentage 2.42 5.66 7.88 6.64 8.48 32.11
Type of missing
-1 -8 -9 NA
Frequency 2295.00 0 1177.00 0
Percentage 24.33 0 12.48 0

SCFAMH
Sample size Missing values
9432 1953
Category
1 2 3 4 5 6
Frequency 1373.00 2550.00 1795.00 948.00 370.00 443.0
Percentage 14.56 27.04 19.03 10.05 3.92 4.7
Type of missing
-1 -8 -9 NA
Frequency 1791.00 0 162.00 0
Percentage 18.99 0 1.72 0

SCFAMI
Sample size Missing values
9432 2925
Category
1 2 3 4 5 6
Frequency 98.00 236.0 571.00 752.00 1084.00 3766.00
Percentage 1.04 2.5 6.05 7.97 11.49 39.93
Type of missing
-1 -8 -9 NA
Frequency 1791.00 0 1134.00 0
Percentage 18.99 0 12.02 0

DHR2
Sample size Missing values
9432 5736
Category
1 2 3 6 7 8 9 10 11 12 13 17 18 20 21 22
Frequency 3136.00 187.00 31.00 2.00 1.00 241.00 3.00 1.00 7.00 5.00 20.00 1.00 3.00 11.00 5.00 42.00
Percentage 33.25 1.98 0.33 0.02 0.01 2.56 0.03 0.01 0.07 0.05 0.21 0.01 0.03 0.12 0.05 0.45
Type of missing
-1 -8 -9 96 NA
Frequency 2155.00 0 0 3581.00 0
Percentage 22.85 0 0 37.97 0

DHR3
Sample size Missing values
9432 7979
Category
1 2 3 7 8 9 10 11 12 13 14 15 18 20 21 22
Frequency 36.00 24.00 25.00 10.00 1147.00 27.00 4.00 43.00 22.00 8.00 1.00 1.00 2.00 54.00 9.0 40.00
Percentage 0.38 0.25 0.27 0.11 12.16 0.29 0.04 0.46 0.23 0.08 0.01 0.01 0.02 0.57 0.1 0.42
Type of missing
-1 -8 -9 96 NA
Frequency 7903.00 0 0 76.00 0
Percentage 83.79 0 0 0.81 0

DHR4
Sample size Missing values
9432 8576
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 14.00 6.00 9.0 1.00 7.00 642.00 14.00 12.00 25.00 17.00 5.00 1.00 59.00 3.00 41.00
Percentage 0.15 0.06 0.1 0.01 0.07 6.81 0.15 0.13 0.27 0.18 0.05 0.01 0.63 0.03 0.43
Type of missing
-1 -8 -9 96 NA
Frequency 8558.00 0 0 18.00 0
Percentage 90.73 0 0 0.19 0

DHR5
Sample size Missing values
9432 9140
Category
1 2 3 7 8 10 11 12 13 20 21 22
Frequency 3.00 6.00 1.00 1.00 195.00 1.00 13.00 8.00 3.00 34.00 5.00 22.00
Percentage 0.03 0.06 0.01 0.01 2.07 0.01 0.14 0.08 0.03 0.36 0.05 0.23
Type of missing
-1 -8 -9 96 NA
Frequency 9129.00 0 0 11.00 0
Percentage 96.79 0 0 0.12 0

DHR6
Sample size Missing values
9432 9319
Category
1 2 3 7 8 11 12 13 20 21 22
Frequency 1.00 2.00 2.00 1.00 65.00 1.00 4.00 1.00 19.0 1.00 16.00
Percentage 0.01 0.02 0.02 0.01 0.69 0.01 0.04 0.01 0.2 0.01 0.17
Type of missing
-1 -8 -9 96 NA
Frequency 9315.00 0 0 4.00 0
Percentage 98.76 0 0 0.04 0

DHR7
Sample size Missing values
9432 9394
Category
2 8 10 11 12 20 22
Frequency 2.00 13.00 2.00 1.00 2.00 12.00 6.00
Percentage 0.02 0.14 0.02 0.01 0.02 0.13 0.06
Type of missing
-1 -8 -9 96 NA
Frequency 9393.00 0 0 1.00 0
Percentage 99.59 0 0 0.01 0

DHR8
Sample size Missing values
9432 9412
Category
2 8 10 11 20 22
Frequency 1.00 6.00 2.00 2.00 5.00 4.00
Percentage 0.01 0.06 0.02 0.02 0.05 0.04
Type of missing
-1 -8 -9 96 NA
Frequency 9411.00 0 0 1.00 0
Percentage 99.78 0 0 0.01 0

DHR9
Sample size Missing values
9432 9427
Category
8 20 22
Frequency 2.00 2.00 1.00
Percentage 0.02 0.02 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 9427.00 0 0 0 0
Percentage 99.95 0 0 0 0

DHR10
Sample size Missing values
9432 9429
Category
12 20
Frequency 2.00 1.00
Percentage 0.02 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 9429.00 0 0 0 0
Percentage 99.97 0 0 0 0

DHR11
Sample size Missing values
9432 9430
Category
20 22
Frequency 1.00 1.00
Percentage 0.01 0.01
Type of missing
-1 -8 -9 96 NA
Frequency 9430.00 0 0 0 0
Percentage 99.98 0 0 0 0

DHR12
Sample size Missing values
9432 9431
Category
22
Frequency 1.00
Percentage 0.01
Type of missing
-1 -8 -9 NA
Frequency 9431.00 0 0 0
Percentage 99.99 0 0 0

2.1.2.2 Harmonisation algorithm

To compute the harmonize variable from the study-specific variable it has to be recoded as follows: * scchdg OR scfamg in {1,2,3} OR scchdh OR scchdi OR scfamh OR scfami in {1,2} OR any of DhR2,..,DhR12 in 1:21 into 1 * scchdg AND scfamg in {4,5,6} AND scchdh AND scchdi AND scfamh AND scfami in {3,4,5,6} AND all DhR2,..,DhR12 not in 1:21 into 0 * scchdg AND scfamg AND scchdh AND scchdi AND scfami in (-9,NA) AND DhR2 AND,..., AND DhR13 in (-8,-9,96,NA) into 999 * scchdg AND scfamg AND scchdh AND scchdi AND scfami AND DhR2 AND,.., AND DhR13 = -1 into 996

R script:

ELSA_ds_w2 <- tibble(id = ELSA_w2_cont_rel$id)

ELSA_w2_cont_rel$scchdg <- car::recode(as.vector(ELSA_w2_cont_rel$scchdg), "NA='-999'")
ELSA_w2_cont_rel$scfamg <- car::recode(as.vector(ELSA_w2_cont_rel$scfamg), "NA='-999'")
ELSA_w2_cont_rel$scchdh <- car::recode(as.vector(ELSA_w2_cont_rel$scchdh), "NA='-999'")
ELSA_w2_cont_rel$scchdi <- car::recode(as.vector(ELSA_w2_cont_rel$scchdi), "NA='-999'")
ELSA_w2_cont_rel$scfami <- car::recode(as.vector(ELSA_w2_cont_rel$scfamh), "NA='-999'")
ELSA_w2_cont_rel$scfami <- car::recode(as.vector(ELSA_w2_cont_rel$scfami), "NA='-999'")
ELSA_w2_cont_rel$DhR2 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR2), "NA='-999'")
ELSA_w2_cont_rel$DhR3 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR3), "NA='-999'")
ELSA_w2_cont_rel$DhR4 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR4), "NA='-999'")
ELSA_w2_cont_rel$DhR5 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR5), "NA='-999'")
ELSA_w2_cont_rel$DhR6 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR6), "NA='-999'")
ELSA_w2_cont_rel$DhR7 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR7), "NA='-999'")
ELSA_w2_cont_rel$DhR8 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR8), "NA='-999'")
ELSA_w2_cont_rel$DhR9 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR9), "NA='-999'")
ELSA_w2_cont_rel$DhR10 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR10), "NA='-999'")
ELSA_w2_cont_rel$DhR11 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR11), "NA='-999'")
ELSA_w2_cont_rel$DhR12 <- car::recode(as.vector(ELSA_w2_cont_rel$DhR12), "NA='-999'")


ELSA_ds_w2$cont_rel <- c(NA)
for (i in 1:dim(ELSA_w2_cont_rel)[1]) {
    if (ELSA_w2_cont_rel$scchdg[i] %in% c(1, 2, 3) | ELSA_w2_cont_rel$scfamg[i] %in% 
        c(1, 2, 3) | ELSA_w2_cont_rel$scchdh[i] %in% c(1, 2) | ELSA_w2_cont_rel$scchdi[i] %in% 
        c(1, 2) | ELSA_w2_cont_rel$scfamh[i] %in% c(1, 2) | ELSA_w2_cont_rel$scfami[i] %in% 
        c(1, 2) | ELSA_w2_cont_rel$DhR2[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR3[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR4[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR5[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR6[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR7[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR8[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR9[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR10[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR11[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR12[i] %in% c(1:21)) {
        ELSA_ds_w2$cont_rel[i] = 1
    } else if (ELSA_w2_cont_rel$scchdg[i] %in% c(-9, -999) & ELSA_w2_cont_rel$scfamg[i] %in% 
        c(-9, -999) & ELSA_w2_cont_rel$scchdh[i] %in% c(-9, -999) & ELSA_w2_cont_rel$scchdi[i] %in% 
        c(-9, -999) & ELSA_w2_cont_rel$scfamh[i] %in% c(-9, -999) & ELSA_w2_cont_rel$scfami[i] %in% 
        c(-9, -999) & ELSA_w2_cont_rel$DhR2[i] %in% c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR3[i] %in% 
        c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR4[i] %in% c(96, -8, -9, -999) & 
        ELSA_w2_cont_rel$DhR5[i] %in% c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR6[i] %in% 
        c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR7[i] %in% c(96, -8, -9, -999) & 
        ELSA_w2_cont_rel$DhR8[i] %in% c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR9[i] %in% 
        c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR10[i] %in% c(96, -8, -9, -999) & 
        ELSA_w2_cont_rel$DhR11[i] %in% c(96, -8, -9, -999) & ELSA_w2_cont_rel$DhR12[i] %in% 
        c(96, -8, -9, -999)) {
        ELSA_ds_w2$cont_rel[i] = 999
    } else if (ELSA_w2_cont_rel$scchdg[i] == -1 & ELSA_w2_cont_rel$scfamg[i] == 
        -1 & ELSA_w2_cont_rel$scchdh[i] == -1 & ELSA_w2_cont_rel$scchdi[i] == 
        -1 & ELSA_w2_cont_rel$scfamh[i] == -1 & ELSA_w2_cont_rel$scfami[i] == 
        -1 & ELSA_w2_cont_rel$DhR2[i] == -1 & ELSA_w2_cont_rel$DhR3[i] == -1 & 
        ELSA_w2_cont_rel$DhR4[i] == -1 & ELSA_w2_cont_rel$DhR5[i] == -1 & ELSA_w2_cont_rel$DhR6[i] == 
        -1 & ELSA_w2_cont_rel$DhR7[i] == -1 & ELSA_w2_cont_rel$DhR8[i] == -1 & 
        ELSA_w2_cont_rel$DhR9[i] == -1 & ELSA_w2_cont_rel$DhR10[i] == -1 & ELSA_w2_cont_rel$DhR11[i] == 
        -1 & ELSA_w2_cont_rel$DhR12[i] == -1) {
        ELSA_ds_w2$cont_rel[i] = 996
    } else if (ELSA_w2_cont_rel$scchdg[i] %in% c(4, 5, 6) & ELSA_w2_cont_rel$scfamg[i] %in% 
        c(4, 5, 6) & ELSA_w2_cont_rel$scchdh[i] %in% c(3, 4, 5, 6) & ELSA_w2_cont_rel$scchdi[i] %in% 
        c(3, 4, 5, 6) & ELSA_w2_cont_rel$scfamh[i] %in% c(3, 4, 5, 6) & ELSA_w2_cont_rel$scfami[i] %in% 
        c(3, 4, 5, 6) & !(ELSA_w2_cont_rel$DhR2[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR3[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR4[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR5[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR6[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR7[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR8[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR9[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR10[i] %in% c(1:21) | ELSA_w2_cont_rel$DhR11[i] %in% 
        c(1:21) | ELSA_w2_cont_rel$DhR12[i] %in% c(1:21))) {
        ELSA_ds_w2$cont_rel[i] = 0
    }
}

ELSA_ds_w2$cont_rel <- car::recode(as.vector(ELSA_ds_w2$cont_rel), "NA='999'")
ELSA_ds_w2$cont_rel <- labelled(ELSA_ds_w2$cont_rel, labels = c(No = 0, Yes = 1, 
    Missing = 999, `Do not know` = 998, Refuse = 997, `Not applicable` = 996, 
    `Don't answer` = 995, `Not attempt/not done/not yet recorded` = 994, `Disable to measure` = 993, 
    Impute = 992, `CAPI/interviewer error` = 991))

2.1.2.3 Statistical description of the new harmonised variable

Sample size Missing values
9432 1042
Category
0 1
Frequency 112.00 8278.00
Percentage 1.19 87.77
Type of missing
991 992 993 994 995 996 997 998 999 NA
Frequency 0 0 0 0 0 440.00 0 0 602.00 0
Percentage 0 0 0 0 0 4.66 0 0 6.38 0

2.1.2.4 Validation

2.1.3 Wave 3

2.1.3.1 Study-specific variable description

The study-specific variable elected to be harmonised is:

  • Name: scchdg
  • Label: On average how often do you meet up with your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scfamg
  • Label: On average how often meet up with family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scchdh
  • Label: on average how often do you speak on the phone to your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scchdi
  • Label: on average how often do you write or email your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scfamh
  • Label: How often the respondent speaks with other relatives on the phone
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scfami
  • Label: on average how often do you write or email family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: dhr1 UP TO dhr12
  • Label: Relationship of this person to Person 2 in the household
  • Categories:
    • 1 = Husband/Wife
    • 2 = Partner/cohabitee
    • 3 = Natural son/daughter
    • 4 = Adopted son/daughter
    • 5 = Foster son/daughter
    • 6 = Step son/daughter/child of partner
    • 7 = Son/daughter-in-law
    • 8 = Natural parent
    • 9 = Adoptive parent
    • 10 = Foster parent
    • 11 = Stepparent/parent s partner
    • 12 = Parent-in-law
    • 13 = Natural brother/sister
    • 14 = Half-brother/sister
    • 15 = Step-brother/sister
    • 16 = Adopted brother/sister
    • 17 = Foster brother/sister
    • 18 = Brother/sister-in-law
    • 19 = Grandchild
    • 20 = Grandparent
    • 21 = Other relative
    • 22 = Other non-relative
    • 96 = (THIS CODE NOT USED)
  • Missings:
    • -9 = Refusal
    • -8 = Don't Know
    • -2 = Schedule not applicable
    • -1 = Not applicable
  • Description:
SCCHDG
Sample size Missing values
9771 3226
Category
1 2 3 4 5 6
Frequency 1521.00 2269.00 1387.0 927.00 252.00 189.00
Percentage 15.57 23.22 14.2 9.49 2.58 1.93
Type of missing
-1 -8 -9 NA
Frequency 2711.00 0 515.00 0
Percentage 27.75 0 5.27 0

SCFAMG
Sample size Missing values
9771 2405
Category
1 2 3 4 5 6
Frequency 745.00 1697.00 1491.00 1638.00 1067.00 728.00
Percentage 7.62 17.37 15.26 16.76 10.92 7.45
Type of missing
-1 -8 -9 NA
Frequency 2232.00 0 173.00 0
Percentage 22.84 0 1.77 0

SCCHDH
Sample size Missing values
9771 3202
Category
1 2 3 4 5 6
Frequency 2828.00 2810.00 623.00 124.00 51.00 133.00
Percentage 28.94 28.76 6.38 1.27 0.52 1.36
Type of missing
-1 -8 -9 NA
Frequency 2711.00 0 491.00 0
Percentage 27.75 0 5.03 0

SCCHDI
Sample size Missing values
9771 3989
Category
1 2 3 4 5 6
Frequency 300.00 653.00 800.00 573.00 720.00 2736
Percentage 3.07 6.68 8.19 5.86 7.37 28
Type of missing
-1 -8 -9 NA
Frequency 2711.00 0 1278.00 0
Percentage 27.75 0 13.08 0

SCFAMH
Sample size Missing values
9771 2385
Category
1 2 3 4 5 6
Frequency 1325.00 2546.00 1836.00 919.00 389.00 371.0
Percentage 13.56 26.06 18.79 9.41 3.98 3.8
Type of missing
-1 -8 -9 NA
Frequency 2232.00 0 153.00 0
Percentage 22.84 0 1.57 0

SCFAMI
Sample size Missing values
9771 3323
Category
1 2 3 4 5 6
Frequency 124.00 322.0 673.00 823.00 1052.00 3454.00
Percentage 1.27 3.3 6.89 8.42 10.77 35.35
Type of missing
-1 -8 -9 NA
Frequency 2232.00 0 1091.00 0
Percentage 22.84 0 11.17 0

DHR2
Sample size Missing values
9771 5923
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 3221.00 229.00 23.00 1.00 1.00 281.00 2.00 1.00 7.00 5.00 25.00 2.00 10.0 3.00 37.00
Percentage 32.96 2.34 0.24 0.01 0.01 2.88 0.02 0.01 0.07 0.05 0.26 0.02 0.1 0.03 0.38
Type of missing
-1 -2 -8 -9 96 NA
Frequency 2139.00 0 0 0 3784.00 0
Percentage 21.89 0 0 0 38.73 0

DHR3
Sample size Missing values
9771 7918
Category
1 2 3 7 8 9 10 11 12 13 18 20 21 22
Frequency 49.0 29.0 26.00 19.00 1524.0 26.00 3.00 46.00 18.00 8.00 3.00 47.00 7.00 48.00
Percentage 0.5 0.3 0.27 0.19 15.6 0.27 0.03 0.47 0.18 0.08 0.03 0.48 0.07 0.49
Type of missing
-1 -2 -8 -9 96 NA
Frequency 7826.00 0 0 0 92.00 0
Percentage 80.09 0 0 0 0.94 0

DHR4
Sample size Missing values
9771 8517
Category
1 2 3 6 7 8 9 10 11 12 13 20 21 22
Frequency 19.00 8.00 7.00 2.00 3.00 1056.00 9.00 6.00 37.00 27.00 3.00 43.00 5.00 29.0
Percentage 0.19 0.08 0.07 0.02 0.03 10.81 0.09 0.06 0.38 0.28 0.03 0.44 0.05 0.3
Type of missing
-1 -2 -8 -9 96 NA
Frequency 8494.00 0 0 0 23.00 0
Percentage 86.93 0 0 0 0.24 0

DHR5
Sample size Missing values
9771 9288
Category
1 2 3 7 8 9 10 11 12 13 18 20 21 22
Frequency 3.00 9.00 8.00 6.00 347.00 2.00 3.00 16.00 16.00 1.00 2.00 42.00 7.00 21.00
Percentage 0.03 0.09 0.08 0.06 3.55 0.02 0.03 0.16 0.16 0.01 0.02 0.43 0.07 0.21
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9278.00 0 0 0 10.0 0
Percentage 94.95 0 0 0 0.1 0

DHR6
Sample size Missing values
9771 9603
Category
1 2 3 7 8 10 11 12 20 21 22
Frequency 2.00 2.00 3.00 3.00 106.00 6.00 3.00 4.00 22.00 3.00 14.00
Percentage 0.02 0.02 0.03 0.03 1.08 0.06 0.03 0.04 0.23 0.03 0.14
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9600.00 0 0 0 3.00 0
Percentage 98.25 0 0 0 0.03 0

DHR7
Sample size Missing values
9771 9724
Category
1 2 8 9 10 11 12 20 22
Frequency 1.00 2.00 21.00 1.00 2.00 2.00 1.00 14.00 3.00
Percentage 0.01 0.02 0.21 0.01 0.02 0.02 0.01 0.14 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9722.0 0 0 0 2.00 0
Percentage 99.5 0 0 0 0.02 0

DHR8
Sample size Missing values
9771 9744
Category
2 8 10 11 12 20 22
Frequency 1.00 12.00 1.00 1.00 3.00 5.00 4.00
Percentage 0.01 0.12 0.01 0.01 0.03 0.05 0.04
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9743.00 0 0 0 1.00 0
Percentage 99.71 0 0 0 0.01 0

DHR9
Sample size Missing values
9771 9754
Category
8 20 21 22
Frequency 7.00 7.00 1.00 2.00
Percentage 0.07 0.07 0.01 0.02
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9754.00 0 0 0 0 0
Percentage 99.83 0 0 0 0 0

DHR10
Sample size Missing values
9771 9761
Category
2 8 12 20
Frequency 1.00 4.00 2.00 3.00
Percentage 0.01 0.04 0.02 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9760.00 0 0 0 1.00 0
Percentage 99.89 0 0 0 0.01 0

DHR11
Sample size Missing values
9771 9763
Category
12 20 21 22
Frequency 2.00 3.00 2.00 1.00
Percentage 0.02 0.03 0.02 0.01
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9763.00 0 0 0 0 0
Percentage 99.92 0 0 0 0 0

DHR12
Sample size Missing values
9771 9770
Category
22
Frequency 1.00
Percentage 0.01
Type of missing
-1 -8 -9 NA
Frequency 9770.00 0 0 0
Percentage 99.99 0 0 0

2.1.3.2 Harmonisation algorithm

To compute the harmonize variable from the study-specific variable it has to be recoded as follows:

  • scchdg OR scfamg in {1,2,3} OR scchdh OR scchdi OR scfamh OR scfami in {1,2} OR any of dhr2,..,dhr12 in 1:21 into 1
  • scchdg AND scfamg in {4,5,6} AND scchdh AND scchdi AND scfamh AND scfami in {3,4,5,6} AND all dhr2,..,dhr12 not in 1:21 into 0
  • scchdg AND scfamg AND scchdh AND scchdi AND scfamh AND scfami in (-9,NA) AND dhr2 AND,..., AND dhr12 in (-8,-9,96,NA) into 999
  • scchdg AND scfamg AND scchdh AND scchdi AND scfamh AND scfami AND dhr2 AND,.., AND dhr12 in (-1,-2) into 996

R script:

ELSA_ds_w3 <- tibble(id = ELSA_w3_cont_rel$id)

ELSA_w3_cont_rel$scchdg <- car::recode(as.vector(ELSA_w3_cont_rel$scchdg), "NA='-999'")
ELSA_w3_cont_rel$scfamg <- car::recode(as.vector(ELSA_w3_cont_rel$scfamg), "NA='-999'")
ELSA_w3_cont_rel$scchdh <- car::recode(as.vector(ELSA_w3_cont_rel$scchdh), "NA='-999'")
ELSA_w3_cont_rel$scchdi <- car::recode(as.vector(ELSA_w3_cont_rel$scchdi), "NA='-999'")
ELSA_w3_cont_rel$scfami <- car::recode(as.vector(ELSA_w3_cont_rel$scfami), "NA='-999'")
ELSA_w3_cont_rel$dhr2 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr2), "NA='-999'")
ELSA_w3_cont_rel$dhr3 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr3), "NA='-999'")
ELSA_w3_cont_rel$dhr4 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr4), "NA='-999'")
ELSA_w3_cont_rel$dhr5 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr5), "NA='-999'")
ELSA_w3_cont_rel$dhr6 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr6), "NA='-999'")
ELSA_w3_cont_rel$dhr7 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr7), "NA='-999'")
ELSA_w3_cont_rel$dhr8 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr8), "NA='-999'")
ELSA_w3_cont_rel$dhr9 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr9), "NA='-999'")
ELSA_w3_cont_rel$dhr10 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr10), "NA='-999'")
ELSA_w3_cont_rel$dhr11 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr11), "NA='-999'")
ELSA_w3_cont_rel$dhr12 <- car::recode(as.vector(ELSA_w3_cont_rel$dhr12), "NA='-999'")


ELSA_ds_w3$cont_rel <- c(NA)
for (i in 1:dim(ELSA_w3_cont_rel)[1]) {
    if (ELSA_w3_cont_rel$scchdg[i] %in% c(1, 2, 3) | ELSA_w3_cont_rel$scfamg[i] %in% 
        c(1, 2, 3) | ELSA_w3_cont_rel$scchdh[i] %in% c(1, 2) | ELSA_w3_cont_rel$scchdi[i] %in% 
        c(1, 2) | ELSA_w3_cont_rel$scfamh[i] %in% c(1, 2) | ELSA_w3_cont_rel$scfami[i] %in% 
        c(1, 2) | ELSA_w3_cont_rel$dhr2[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr3[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr4[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr5[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr6[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr7[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr8[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr9[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr10[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr11[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr12[i] %in% c(1:21)) {
        ELSA_ds_w3$cont_rel[i] = 1
    } else if (ELSA_w3_cont_rel$scchdg[i] %in% c(-9, -999) & ELSA_w3_cont_rel$scfamg[i] %in% 
        c(-9, -999) & ELSA_w3_cont_rel$scchdh[i] %in% c(-9, -999) & ELSA_w3_cont_rel$scchdi[i] %in% 
        c(-9, -999) & ELSA_w3_cont_rel$scfamh[i] %in% c(-9, -999) & ELSA_w3_cont_rel$scfami[i] %in% 
        c(-9, -999) & ELSA_w3_cont_rel$dhr2[i] %in% c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr3[i] %in% 
        c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr4[i] %in% c(96, -8, -9, -999) & 
        ELSA_w3_cont_rel$dhr5[i] %in% c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr6[i] %in% 
        c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr7[i] %in% c(96, -8, -9, -999) & 
        ELSA_w3_cont_rel$dhr8[i] %in% c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr9[i] %in% 
        c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr10[i] %in% c(96, -8, -9, -999) & 
        ELSA_w3_cont_rel$dhr11[i] %in% c(96, -8, -9, -999) & ELSA_w3_cont_rel$dhr12[i] %in% 
        c(96, -8, -9, -999)) {
        ELSA_ds_w3$cont_rel[i] = 999
    } else if (ELSA_w3_cont_rel$scchdg[i] == -1 & ELSA_w3_cont_rel$scfamg[i] == 
        -1 & ELSA_w3_cont_rel$scchdh[i] == -1 & ELSA_w3_cont_rel$scchdi[i] == 
        -1 & ELSA_w3_cont_rel$scfamh[i] == -1 & ELSA_w3_cont_rel$scfami[i] == 
        -1 & ELSA_w3_cont_rel$dhr2[i] %in% c(-1, -2) & ELSA_w3_cont_rel$dhr3[i] %in% 
        c(-1, -2) & ELSA_w3_cont_rel$dhr4[i] %in% c(-1, -2) & ELSA_w3_cont_rel$dhr5[i] %in% 
        c(-1, -2) & ELSA_w3_cont_rel$dhr6[i] %in% c(-1, -2) & ELSA_w3_cont_rel$dhr7[i] %in% 
        c(-1, -2) & ELSA_w3_cont_rel$dhr8[i] %in% c(-1, -2) & ELSA_w3_cont_rel$dhr9[i] %in% 
        c(-1, -2) & ELSA_w3_cont_rel$dhr10[i] %in% c(-1, -2) & ELSA_w3_cont_rel$dhr11[i] %in% 
        c(-1, -2) & ELSA_w3_cont_rel$dhr12[i] %in% c(-1, -2)) {
        ELSA_ds_w3$cont_rel[i] = 996
    } else if (ELSA_w3_cont_rel$scchdg[i] %in% c(4, 5, 6) & ELSA_w3_cont_rel$scfamg[i] %in% 
        c(4, 5, 6) & ELSA_w3_cont_rel$scchdh[i] %in% c(3, 4, 5, 6) & ELSA_w3_cont_rel$scchdi[i] %in% 
        c(3, 4, 5, 6) & ELSA_w3_cont_rel$scfamh[i] %in% c(3, 4, 5, 6) & ELSA_w3_cont_rel$scfami[i] %in% 
        c(3, 4, 5, 6) & !(ELSA_w3_cont_rel$dhr2[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr3[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr4[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr5[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr6[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr7[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr8[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr9[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr10[i] %in% c(1:21) | ELSA_w3_cont_rel$dhr11[i] %in% 
        c(1:21) | ELSA_w3_cont_rel$dhr12[i] %in% c(1:21))) {
        ELSA_ds_w3$cont_rel[i] = 0
    }
}

ELSA_ds_w3$cont_rel <- car::recode(as.vector(ELSA_ds_w3$cont_rel), "NA='999'")
ELSA_ds_w3$cont_rel <- labelled(ELSA_ds_w3$cont_rel, labels = c(No = 0, Yes = 1, 
    Missing = 999, `Do not know` = 998, Refuse = 997, `Not applicable` = 996, 
    `Don't answer` = 995, `Not attempt/not done/not yet recorded` = 994, `Disable to measure` = 993, 
    Impute = 992, `CAPI/interviewer error` = 991))

2.1.3.3 Statistical description of the new harmonised variable

Sample size Missing values
9771 1165
Category
0 1
Frequency 104.00 8502.00
Percentage 1.06 87.01
Type of missing
991 992 993 994 995 996 997 998 999 NA
Frequency 0 0 0 0 0 473.00 0 0 692.00 0
Percentage 0 0 0 0 0 4.84 0 0 7.08 0

2.1.3.4 Validation

2.1.4 Wave 4

2.1.4.1 Study-specific variable description

The study-specific variable elected to be harmonised is:

  • Name: scchdg
  • Label: On average how often do you meet up with your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scfamg
  • Label: On average how often meet up with family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scchdh
  • Label: on average how often do you speak on the phone to your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scchdi
  • Label: on average how often do you write or email your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: scfami
  • Label: How often the respondent writes to or emails other relatives
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -1 = Item not applicable
  • Name: dhr2 UP TO dhr12 (dhr13 to dhr16 have NA or -1 only)
  • Label: Relationship of this person to Person 1 in the household
  • Categories:
    • 1 = Husband/Wife
    • 2 = Partner/cohabitee
    • 3 = Natural son/daughter
    • 4 = Adopted son/daughter
    • 5 = Foster son/daughter
    • 6 = Step son/daughter/child of partner
    • 7 = Son/daughter-in-law
    • 8 = Natural parent
    • 9 = Adoptive parent
    • 10 = Foster parent
    • 11 = Stepparent/parent s partner
    • 12 = Parent-in-law
    • 13 = Natural brother/sister
    • 14 = Half-brother/sister
    • 15 = Step-brother/sister
    • 16 = Adopted brother/sister
    • 17 = Foster brother/sister
    • 18 = Brother/sister-in-law
    • 19 = Grandchild
    • 20 = Grandparent
    • 21 = Other relative
    • 22 = Other non-relative
    • 96 = (THIS CODE NOT USED)
  • Missings:
    • -9 = Refusal
    • -8 = Don't Know
    • -2 = Schedule not applicable
    • -1 = Not applicable
  • Description:
SCCHDG
Sample size Missing values
11050 3594
Category
1 2 3 4 5 6
Frequency 1690.00 2538.00 1613.0 1083.0 307.00 225.00
Percentage 15.29 22.97 14.6 9.8 2.78 2.04
Type of missing
-1 -8 -9 NA
Frequency 3096.00 0 498.00 0
Percentage 28.02 0 4.51 0

SCFAMG
Sample size Missing values
11050 2687
Category
1 2 3 4 5 6
Frequency 844.00 1904.00 1674.00 1780.00 1256.00 905.00
Percentage 7.64 17.23 15.15 16.11 11.37 8.19
Type of missing
-1 -8 -9 NA
Frequency 2494.00 0 193.00 0
Percentage 22.57 0 1.75 0

SCCHDH
Sample size Missing values
11050 3570
Category
1 2 3 4 5 6
Frequency 3249.0 3154.00 720.00 156.00 48.00 153.00
Percentage 29.4 28.54 6.52 1.41 0.43 1.38
Type of missing
-1 -8 -9 NA
Frequency 3096.00 0 474.00 0
Percentage 28.02 0 4.29 0

SCCHDI
Sample size Missing values
11050 4173
Category
1 2 3 4 5 6
Frequency 462.00 963.00 1007.00 651.00 782.00 3012.00
Percentage 4.18 8.71 9.11 5.89 7.08 27.26
Type of missing
-1 -8 -9 NA
Frequency 3096.00 0 1077.00 0
Percentage 28.02 0 9.75 0

SCFAMI
Sample size Missing values
11050 3376
Category
1 2 3 4 5 6
Frequency 175.00 527.00 975.00 932.00 1127.0 3938.00
Percentage 1.58 4.77 8.82 8.43 10.2 35.64
Type of missing
-1 -8 -9 NA
Frequency 2494.00 0 882.00 0
Percentage 22.57 0 7.98 0

DHR2
Sample size Missing values
11050 6509
Category
1 2 3 6 7 8 9 10 11 12 13 15 18 20 21 22
Frequency 3744.00 278.00 28.00 1.00 1.00 365.0 5.00 1.00 9.00 4.00 25.00 1.00 2.00 19.00 5.00 53.00
Percentage 33.88 2.52 0.25 0.01 0.01 3.3 0.05 0.01 0.08 0.04 0.23 0.01 0.02 0.17 0.05 0.48
Type of missing
-1 -2 -8 -9 96 NA
Frequency 2188.0 0 0 0 4321.0 0
Percentage 19.8 0 0 0 39.1 0

DHR3
Sample size Missing values
11050 8552
Category
1 2 3 4 7 8 9 10 11 12 13 14 18 20 21 22
Frequency 58.00 33.0 36.00 1.00 25.00 2034.00 26.00 2.00 74.00 21.00 16.00 1.00 6.00 83.00 18.00 64.00
Percentage 0.52 0.3 0.33 0.01 0.23 18.41 0.24 0.02 0.67 0.19 0.14 0.01 0.05 0.75 0.16 0.58
Type of missing
-1 -2 -8 -9 96 NA
Frequency 8453.0 0 0 0 99.0 0
Percentage 76.5 0 0 0 0.9 0

DHR4
Sample size Missing values
11050 9493
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 23.00 7.00 10.00 1.00 5.00 1281.00 12.00 7.00 42.00 43.00 5.00 1.00 73.00 6.00 41.00
Percentage 0.21 0.06 0.09 0.01 0.05 11.59 0.11 0.06 0.38 0.39 0.05 0.01 0.66 0.05 0.37
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9465.00 0 0 0 28.00 0
Percentage 85.66 0 0 0 0.25 0

DHR5
Sample size Missing values
11050 10491
Category
1 2 3 7 8 9 10 11 12 13 20 21 22
Frequency 4.00 10.00 9.00 5.00 380.00 2.00 3.00 19.00 23.00 3.00 71.00 2.00 28.00
Percentage 0.04 0.09 0.08 0.05 3.44 0.02 0.03 0.17 0.21 0.03 0.64 0.02 0.25
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10482.00 0 0 0 9.00 0
Percentage 94.86 0 0 0 0.08 0

DHR6
Sample size Missing values
11050 10826
Category
1 2 3 7 8 9 10 11 12 13 20 21 22
Frequency 3.00 3.00 1.00 2.00 119.00 1.00 6.00 7.00 10.00 2.00 48.00 3.00 19.00
Percentage 0.03 0.03 0.01 0.02 1.08 0.01 0.05 0.06 0.09 0.02 0.43 0.03 0.17
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10821.00 0 0 0 5.00 0
Percentage 97.93 0 0 0 0.05 0

DHR7
Sample size Missing values
11050 10978
Category
1 2 3 7 8 10 11 12 20 21 22
Frequency 1.00 1.00 1.00 1.00 20.00 2.00 3.00 5.00 28.00 3.00 7.00
Percentage 0.01 0.01 0.01 0.01 0.18 0.02 0.03 0.05 0.25 0.03 0.06
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10976.00 0 0 0 2.00 0
Percentage 99.33 0 0 0 0.02 0

DHR8
Sample size Missing values
11050 11013
Category
2 3 7 8 10 12 13 20 22
Frequency 1.00 1.00 1.00 10.00 3.00 3.00 1.00 13.00 4.00
Percentage 0.01 0.01 0.01 0.09 0.03 0.03 0.01 0.12 0.04
Type of missing
-1 -2 -8 -9 96 NA
Frequency 11012.00 0 0 0 1.00 0
Percentage 99.66 0 0 0 0.01 0

DHR9
Sample size Missing values
11050 11032
Category
8 10 20 21 22
Frequency 4.00 1.00 9.00 1.00 3.00
Percentage 0.04 0.01 0.08 0.01 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 11032.00 0 0 0 0 0
Percentage 99.84 0 0 0 0 0

DHR10
Sample size Missing values
11050 11041
Category
2 8 12 20
Frequency 1.00 2.00 3.00 3.00
Percentage 0.01 0.02 0.03 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 11040.00 0 0 0 1.00 0
Percentage 99.91 0 0 0 0.01 0

DHR11
Sample size Missing values
11050 11044
Category
12 20
Frequency 2.00 4.00
Percentage 0.02 0.04
Type of missing
-1 -2 -8 -9 96 NA
Frequency 11044.00 0 0 0 0 0
Percentage 99.95 0 0 0 0 0

DHR12
Sample size Missing values
11050 11048
Category
12
Frequency 2.00
Percentage 0.02
Type of missing
-1 -8 -9 NA
Frequency 11048.00 0 0 0
Percentage 99.98 0 0 0

2.1.4.2 Harmonisation algorithm

To compute the harmonize variable from the study-specific variable it has to be recoded as follows:

  • scchdg OR scfamg in {1,2,3} OR scchdh OR scchdi OR scfami in {1,2} OR any of dhr2,..,dhr12 in 1:21 into 1
  • scchdg AND scfamg in {4,5,6} AND scchdh AND scchdi AND scfami in {3,4,5,6} AND all dhr2,..,dhr12 not in 1:21 into 0
  • scchdg AND scfamg AND scchdh AND scchdi AND scfami in (-9,NA) AND dhr2 AND,..., AND dhr12 in (-8,-9,96,NA) into 999
  • scchdg AND scfamg AND scchdh AND scchdi AND scfami AND dhr2 AND,.., AND dhr12 in (-1, -2) into 996

R script:

ELSA_ds_w4 <- tibble(id = ELSA_w4_cont_rel$id)

ELSA_w4_cont_rel$scchdg <- car::recode(as.vector(ELSA_w4_cont_rel$scchdg), "NA='-999'")
ELSA_w4_cont_rel$scfamg <- car::recode(as.vector(ELSA_w4_cont_rel$scfamg), "NA='-999'")
ELSA_w4_cont_rel$scchdh <- car::recode(as.vector(ELSA_w4_cont_rel$scchdh), "NA='-999'")
ELSA_w4_cont_rel$scchdi <- car::recode(as.vector(ELSA_w4_cont_rel$scchdi), "NA='-999'")
ELSA_w4_cont_rel$scfami <- car::recode(as.vector(ELSA_w4_cont_rel$scfami), "NA='-999'")
ELSA_w4_cont_rel$dhr2 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr2), "NA='-999'")
ELSA_w4_cont_rel$dhr3 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr3), "NA='-999'")
ELSA_w4_cont_rel$dhr4 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr4), "NA='-999'")
ELSA_w4_cont_rel$dhr5 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr5), "NA='-999'")
ELSA_w4_cont_rel$dhr6 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr6), "NA='-999'")
ELSA_w4_cont_rel$dhr7 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr7), "NA='-999'")
ELSA_w4_cont_rel$dhr8 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr8), "NA='-999'")
ELSA_w4_cont_rel$dhr9 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr9), "NA='-999'")
ELSA_w4_cont_rel$dhr10 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr10), "NA='-999'")
ELSA_w4_cont_rel$dhr11 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr11), "NA='-999'")
ELSA_w4_cont_rel$dhr12 <- car::recode(as.vector(ELSA_w4_cont_rel$dhr12), "NA='-999'")

ELSA_ds_w4$cont_rel <- c(NA)
for (i in 1:dim(ELSA_w4_cont_rel)[1]) {
    if (ELSA_w4_cont_rel$scchdg[i] %in% c(1, 2, 3) | ELSA_w4_cont_rel$scfamg[i] %in% 
        c(1, 2, 3) | ELSA_w4_cont_rel$scchdh[i] %in% c(1, 2) | ELSA_w4_cont_rel$scchdi[i] %in% 
        c(1, 2) | ELSA_w4_cont_rel$scfami[i] %in% c(1, 2) | ELSA_w4_cont_rel$dhr2[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr3[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr4[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr5[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr6[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr7[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr8[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr9[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr10[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr11[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr12[i] %in% 
        c(1:21)) {
        ELSA_ds_w4$cont_rel[i] = 1
    } else if (ELSA_w4_cont_rel$scchdg[i] %in% c(-9, -999) & ELSA_w4_cont_rel$scfamg[i] %in% 
        c(-9, -999) & ELSA_w4_cont_rel$scchdh[i] %in% c(-9, -999) & ELSA_w4_cont_rel$scchdi[i] %in% 
        c(-9, -999) & ELSA_w4_cont_rel$scfami[i] %in% c(-9, -999) & ELSA_w4_cont_rel$dhr2[i] %in% 
        c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr3[i] %in% c(96, -8, -9, -999) & 
        ELSA_w4_cont_rel$dhr4[i] %in% c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr5[i] %in% 
        c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr6[i] %in% c(96, -8, -9, -999) & 
        ELSA_w4_cont_rel$dhr7[i] %in% c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr8[i] %in% 
        c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr9[i] %in% c(96, -8, -9, -999) & 
        ELSA_w4_cont_rel$dhr10[i] %in% c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr11[i] %in% 
        c(96, -8, -9, -999) & ELSA_w4_cont_rel$dhr12[i] %in% c(96, -8, -9, -999)) {
        ELSA_ds_w4$cont_rel[i] = 999
    } else if (ELSA_w4_cont_rel$scchdg[i] == -1 & ELSA_w4_cont_rel$scfamg[i] == 
        -1 & ELSA_w4_cont_rel$scchdh[i] == -1 & ELSA_w4_cont_rel$scchdi[i] == 
        -1 & ELSA_w4_cont_rel$scfami[i] == -1 & ELSA_w4_cont_rel$dhr2[i] %in% 
        c(-1, -2) & ELSA_w4_cont_rel$dhr3[i] %in% c(-1, -2) & ELSA_w4_cont_rel$dhr4[i] %in% 
        c(-1, -2) & ELSA_w4_cont_rel$dhr5[i] %in% c(-1, -2) & ELSA_w4_cont_rel$dhr6[i] %in% 
        c(-1, -2) & ELSA_w4_cont_rel$dhr7[i] %in% c(-1, -2) & ELSA_w4_cont_rel$dhr8[i] %in% 
        c(-1, -2) & ELSA_w4_cont_rel$dhr9[i] %in% c(-1, -2) & ELSA_w4_cont_rel$dhr10[i] %in% 
        c(-1, -2) & ELSA_w4_cont_rel$dhr11[i] %in% c(-1, -2) & ELSA_w4_cont_rel$dhr12[i] %in% 
        c(-1, -2)) {
        ELSA_ds_w4$cont_rel[i] = 996
    } else if (ELSA_w4_cont_rel$scchdg[i] %in% c(4, 5, 6) & ELSA_w4_cont_rel$scfamg[i] %in% 
        c(4, 5, 6) & ELSA_w4_cont_rel$scchdh[i] %in% c(3, 4, 5, 6) & ELSA_w4_cont_rel$scchdi[i] %in% 
        c(3, 4, 5, 6) & ELSA_w4_cont_rel$scfami[i] %in% c(3, 4, 5, 6) & !(ELSA_w4_cont_rel$dhr2[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr3[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr4[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr5[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr6[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr7[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr8[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr9[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr10[i] %in% 
        c(1:21) | ELSA_w4_cont_rel$dhr11[i] %in% c(1:21) | ELSA_w4_cont_rel$dhr12[i] %in% 
        c(1:21))) {
        ELSA_ds_w4$cont_rel[i] = 0
    }
}
ELSA_ds_w4$cont_rel <- car::recode(as.vector(ELSA_ds_w4$cont_rel), "NA='999'")
ELSA_ds_w4$cont_rel <- labelled(ELSA_ds_w4$cont_rel, labels = c(No = 0, Yes = 1, 
    Missing = 999, `Do not know` = 998, Refuse = 997, `Not applicable` = 996, 
    `Don't answer` = 995, `Not attempt/not done/not yet recorded` = 994, `Disable to measure` = 993, 
    Impute = 992, `CAPI/interviewer error` = 991))

2.1.4.3 Statistical description of the new harmonised variable

Sample size Missing values
11050 1389
Category
0 1
Frequency 124.00 9537.00
Percentage 1.12 86.31
Type of missing
991 992 993 994 995 996 997 998 999 NA
Frequency 0 0 0 0 0 468.00 0 0 921.00 0
Percentage 0 0 0 0 0 4.24 0 0 8.33 0

2.1.4.4 Validation

2.1.5 Wave 5

2.1.5.1 Study-specific variable description

The study-specific variable elected to be harmonised is:

  • Name: scchdg
  • Label: On average how often do you meet up with your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfamg
  • Label: On average how often meet up with family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scchdh
  • Label: on average how often do you speak on the phone to your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scchdi
  • Label: on average how often do you write or email your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfamh
  • Label: How often the respondent speaks with other relatives on the phone
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfami
  • Label: on average how often do you write or email family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: dhr1 UP TO dhr16 (dhr13 to dhr16 have NA or -1 only)
  • Label: Relationship of this person to Person 1 in the household
  • Categories:
    • 1 = Husband/Wife
    • 2 = Partner/cohabitee
    • 3 = Natural son/daughter
    • 4 = Adopted son/daughter
    • 5 = Foster son/daughter
    • 6 = Step son/daughter/child of partner
    • 7 = Son/daughter-in-law
    • 8 = Natural parent
    • 9 = Adoptive parent
    • 10 = Foster parent
    • 11 = Stepparent/parent s partner
    • 12 = Parent-in-law
    • 13 = Natural brother/sister
    • 14 = Half-brother/sister
    • 15 = Step-brother/sister
    • 16 = Adopted brother/sister
    • 17 = Foster brother/sister
    • 18 = Brother/sister-in-law
    • 19 = Grandchild
    • 20 = Grandparent
    • 21 = Other relative
    • 22 = Other non-relative
    • 96 = (THIS CODE NOT USED)
  • Missings:
    • -9 = Refusal
    • -8 = Don't Know
    • -2 = Schedule not applicable
    • -1 = Not applicable
  • Description:
SCCHDG
Sample size Missing values
10274 1751
Category
-2 1 2 3 4 5 6
Frequency 1244.00 1575.00 2511.00 1625.00 1067.00 299.00 202.00
Percentage 12.11 15.33 24.44 15.82 10.39 2.91 1.97
Type of missing
-1 -8 -9 NA
Frequency 1332.00 0 419.00 0
Percentage 12.96 0 4.08 0

SCFAMG
Sample size Missing values
10274 913
Category
-2 1 2 3 4 5 6
Frequency 1244.00 770.00 1771.00 1659.00 1799.00 1228.00 890.00
Percentage 12.11 7.49 17.24 16.15 17.51 11.95 8.66
Type of missing
-1 -8 -9 NA
Frequency 748.00 0 165.00 0
Percentage 7.28 0 1.61 0

SCCHDH
Sample size Missing values
10274 1717
Category
-2 1 2 3 4 5 6
Frequency 1244.00 3085.00 3077.00 798.00 157.00 67.00 129.00
Percentage 12.11 30.03 29.95 7.77 1.53 0.65 1.26
Type of missing
-1 -8 -9 NA
Frequency 1332.00 0 385.00 0
Percentage 12.96 0 3.75 0

SCCHDI
Sample size Missing values
10274 2286
Category
-2 1 2 3 4 5 6
Frequency 1244.00 531.00 1071.00 1080.00 641.00 683.00 2738.00
Percentage 12.11 5.17 10.42 10.51 6.24 6.65 26.65
Type of missing
-1 -8 -9 NA
Frequency 1332.00 0 954.00 0
Percentage 12.96 0 9.29 0

SCFAMH
Sample size Missing values
10274 890
Category
-2 1 2 3 4 5 6
Frequency 1244.00 1438 2680.00 2022.00 1047.00 452.0 501.00
Percentage 12.11 14 26.09 19.68 10.19 4.4 4.88
Type of missing
-1 -8 -9 NA
Frequency 748.00 0 142.00 0
Percentage 7.28 0 1.38 0

SCFAMI
Sample size Missing values
10274 1566
Category
-2 1 2 3 4 5 6
Frequency 1244.00 208.00 575.0 1070.00 907.00 1015.00 3689.00
Percentage 12.11 2.02 5.6 10.41 8.83 9.88 35.91
Type of missing
-1 -8 -9 NA
Frequency 748.00 0 818.00 0
Percentage 7.28 0 7.96 0

DHR2
Sample size Missing values
10274 6134
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 3442.0 256.00 30.00 1.00 1.00 307.00 6.00 1.00 8.00 5.00 20.00 2.00 13.00 5.00 43.00
Percentage 33.5 2.49 0.29 0.01 0.01 2.99 0.06 0.01 0.08 0.05 0.19 0.02 0.13 0.05 0.42
Type of missing
-1 -2 -8 -9 96 NA
Frequency 2064.00 0 0 0 4070.00 0
Percentage 20.09 0 0 0 39.61 0

DHR3
Sample size Missing values
10274 8301
Category
1 2 3 4 7 8 9 11 12 13 18 20 21 22
Frequency 63.00 37.00 58.00 1.00 19.00 1541 21.0 64.00 21.0 9.00 4.00 71.00 18.00 46.00
Percentage 0.61 0.36 0.56 0.01 0.18 15 0.2 0.62 0.2 0.09 0.04 0.69 0.18 0.45
Type of missing
-1 -2 -8 -9 96 NA
Frequency 8195.00 0 0 0 106.00 0
Percentage 79.76 0 0 0 1.03 0

DHR4
Sample size Missing values
10274 8925
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 26.00 12.00 33.00 2.00 11.00 1028.00 15.00 8.00 35.00 45.00 6.00 2.00 79.00 8.00 39.00
Percentage 0.25 0.12 0.32 0.02 0.11 10.01 0.15 0.08 0.34 0.44 0.06 0.02 0.77 0.08 0.38
Type of missing
-1 -2 -8 -9 96 NA
Frequency 8897.0 0 0 0 28.00 0
Percentage 86.6 0 0 0 0.27 0

DHR5
Sample size Missing values
10274 9747
Category
1 2 3 6 7 8 9 10 11 12 13 19 20 21 22
Frequency 5.00 9.00 17.00 1.00 10.0 339.0 2.00 4.00 16.00 19.00 4.00 2.00 71.00 2.00 26.00
Percentage 0.05 0.09 0.17 0.01 0.1 3.3 0.02 0.04 0.16 0.18 0.04 0.02 0.69 0.02 0.25
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9734.00 0 0 0 13.00 0
Percentage 94.74 0 0 0 0.13 0

DHR6
Sample size Missing values
10274 10040
Category
1 2 3 7 8 10 11 12 13 20 21 22
Frequency 3.00 5.00 4.00 2.00 115.00 5.00 7.00 16.00 2.00 56.00 5.00 14.00
Percentage 0.03 0.05 0.04 0.02 1.12 0.05 0.07 0.16 0.02 0.55 0.05 0.14
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10034.00 0 0 0 6.00 0
Percentage 97.66 0 0 0 0.06 0

DHR7
Sample size Missing values
10274 10203
Category
1 2 3 7 8 10 11 12 13 20 21 22
Frequency 1.00 1.00 1.00 1.00 20.00 3.00 3.00 4.00 1.00 27.00 4.00 5.00
Percentage 0.01 0.01 0.01 0.01 0.19 0.03 0.03 0.04 0.01 0.26 0.04 0.05
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10199.00 0 0 0 4.00 0
Percentage 99.27 0 0 0 0.04 0

DHR8
Sample size Missing values
10274 10228
Category
2 3 7 8 10 12 13 20 21 22
Frequency 1.00 1.00 1.00 13.00 2.00 2.00 1.00 20.00 1.00 4.00
Percentage 0.01 0.01 0.01 0.13 0.02 0.02 0.01 0.19 0.01 0.04
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10227.00 0 0 0 1.00 0
Percentage 99.54 0 0 0 0.01 0

DHR9
Sample size Missing values
10274 10258
Category
8 10 20 22
Frequency 5.00 2.00 7.00 2.00
Percentage 0.05 0.02 0.07 0.02
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10258.00 0 0 0 0 0
Percentage 99.84 0 0 0 0 0

DHR10
Sample size Missing values
10274 10261
Category
2 8 12 20
Frequency 1.00 4.00 5.00 3.00
Percentage 0.01 0.04 0.05 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10260.00 0 0 0 1.00 0
Percentage 99.86 0 0 0 0.01 0

DHR11
Sample size Missing values
10274 10269
Category
12 20
Frequency 2.00 3.00
Percentage 0.02 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10269.00 0 0 0 0 0
Percentage 99.95 0 0 0 0 0

DHR12
Sample size Missing values
10274 10272
Category
12
Frequency 2.00
Percentage 0.02
Type of missing
-1 -8 -9 NA
Frequency 10272.00 0 0 0
Percentage 99.98 0 0 0

DHR13
Sample size Missing values
10274 10274
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10274 0 0 0
Percentage 100 0 0 0

DHR14
Sample size Missing values
10274 10274
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10274 0 0 0
Percentage 100 0 0 0

DHR15
Sample size Missing values
10274 10274
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10274 0 0 0
Percentage 100 0 0 0

DHR16
Sample size Missing values
10274 10274
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10274 0 0 0
Percentage 100 0 0 0

2.1.5.2 Harmonisation algorithm

To compute the harmonize variable from the study-specific variable it has to be recoded as follows:

  • scchdg OR scfamg in {1,2,3} OR scchdh OR scchdi OR scfamh OR scfami in {1,2} OR any of dhr2,..,dhr16 in 1:21 into 1
  • scchdg AND scfamg in {4,5,6} AND scchdh AND scchdi AND scfamh AND scfami in {3,4,5,6} AND all dhr2,..,dhr16 not in 1:21 into 0
  • scchdg AND scfamg AND scchdh AND scchdi AND scfamh AND scfami in (-9,NA) AND dhr2 AND,..., AND dhr16 in (-8,-9,96,NA) into 999
  • scchdg AND scfamg AND scchdh AND scchdi AND scfamh AND scfami AND dhr2 AND,.., AND dhr16 in (-1,-2) into 996

R script:

ELSA_ds_w5 <- tibble(id = ELSA_w5_cont_rel$id)

ELSA_w5_cont_rel$scchdg <- car::recode(as.vector(ELSA_w5_cont_rel$scchdg), "NA='-999'")
ELSA_w5_cont_rel$scfamg <- car::recode(as.vector(ELSA_w5_cont_rel$scfamg), "NA='-999'")
ELSA_w5_cont_rel$scchdh <- car::recode(as.vector(ELSA_w5_cont_rel$scchdh), "NA='-999'")
ELSA_w5_cont_rel$scchdi <- car::recode(as.vector(ELSA_w5_cont_rel$scchdi), "NA='-999'")
ELSA_w5_cont_rel$scfami <- car::recode(as.vector(ELSA_w5_cont_rel$scfami), "NA='-999'")
ELSA_w5_cont_rel$dhr2 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr2), "NA='-999'")
ELSA_w5_cont_rel$dhr3 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr3), "NA='-999'")
ELSA_w5_cont_rel$dhr4 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr4), "NA='-999'")
ELSA_w5_cont_rel$dhr5 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr5), "NA='-999'")
ELSA_w5_cont_rel$dhr6 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr6), "NA='-999'")
ELSA_w5_cont_rel$dhr7 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr7), "NA='-999'")
ELSA_w5_cont_rel$dhr8 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr8), "NA='-999'")
ELSA_w5_cont_rel$dhr9 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr9), "NA='-999'")
ELSA_w5_cont_rel$dhr10 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr10), "NA='-999'")
ELSA_w5_cont_rel$dhr11 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr11), "NA='-999'")
ELSA_w5_cont_rel$dhr12 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr12), "NA='-999'")
ELSA_w5_cont_rel$dhr13 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr13), "NA='-999'")
ELSA_w5_cont_rel$dhr14 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr14), "NA='-999'")
ELSA_w5_cont_rel$dhr15 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr15), "NA='-999'")
ELSA_w5_cont_rel$dhr16 <- car::recode(as.vector(ELSA_w5_cont_rel$dhr16), "NA='-999'")


ELSA_ds_w5$cont_rel <- c(NA)
for (i in 1:dim(ELSA_w5_cont_rel)[1]) {
    if (ELSA_w5_cont_rel$scchdg[i] %in% c(1, 2, 3) | ELSA_w5_cont_rel$scfamg[i] %in% 
        c(1, 2, 3) | ELSA_w5_cont_rel$scchdh[i] %in% c(1, 2) | ELSA_w5_cont_rel$scchdi[i] %in% 
        c(1, 2) | ELSA_w5_cont_rel$scfamh[i] %in% c(1, 2) | ELSA_w5_cont_rel$scfami[i] %in% 
        c(1, 2) | ELSA_w5_cont_rel$dhr2[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr3[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr4[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr5[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr6[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr7[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr8[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr9[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr10[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr11[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr12[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr13[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr14[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr15[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr16[i] %in% c(1:21)) {
        ELSA_ds_w5$cont_rel[i] = 1
    } else if (ELSA_w5_cont_rel$scchdg[i] %in% c(-9, -999) & ELSA_w5_cont_rel$scfamg[i] %in% 
        c(-9, -999) & ELSA_w5_cont_rel$scchdh[i] %in% c(-9, -999) & ELSA_w5_cont_rel$scchdi[i] %in% 
        c(-9, -999) & ELSA_w5_cont_rel$scfamh[i] %in% c(-9, -999) & ELSA_w5_cont_rel$scfami[i] %in% 
        c(-9, -999) & ELSA_w5_cont_rel$dhr2[i] %in% c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr3[i] %in% 
        c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr4[i] %in% c(96, -8, -9, -999) & 
        ELSA_w5_cont_rel$dhr5[i] %in% c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr6[i] %in% 
        c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr7[i] %in% c(96, -8, -9, -999) & 
        ELSA_w5_cont_rel$dhr8[i] %in% c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr9[i] %in% 
        c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr10[i] %in% c(96, -8, -9, -999) & 
        ELSA_w5_cont_rel$dhr11[i] %in% c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr12[i] %in% 
        c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr13[i] %in% c(96, -8, -9, -999) & 
        ELSA_w5_cont_rel$dhr14[i] %in% c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr15[i] %in% 
        c(96, -8, -9, -999) & ELSA_w5_cont_rel$dhr16[i] %in% c(96, -8, -9, -999)) {
        ELSA_ds_w5$cont_rel[i] = 999
    } else if (ELSA_w5_cont_rel$scchdg[i] == -1 & ELSA_w5_cont_rel$scfamg[i] == 
        -1 & ELSA_w5_cont_rel$scchdh[i] == -1 & ELSA_w5_cont_rel$scchdi[i] == 
        -1 & ELSA_w5_cont_rel$scfamh[i] == -1 & ELSA_w5_cont_rel$scfami[i] == 
        -1 & ELSA_w5_cont_rel$dhr2[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr3[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr4[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr5[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr6[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr7[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr8[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr9[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr10[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr11[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr12[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr13[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr14[i] %in% c(-1, -2) & ELSA_w5_cont_rel$dhr15[i] %in% 
        c(-1, -2) & ELSA_w5_cont_rel$dhr16[i] %in% c(-1, -2)) {
        ELSA_ds_w5$cont_rel[i] = 996
    } else if (ELSA_w5_cont_rel$scchdg[i] %in% c(4, 5, 6) & ELSA_w5_cont_rel$scfamg[i] %in% 
        c(4, 5, 6) & ELSA_w5_cont_rel$scchdh[i] %in% c(3, 4, 5, 6) & ELSA_w5_cont_rel$scchdi[i] %in% 
        c(3, 4, 5, 6) & ELSA_w5_cont_rel$scfamh[i] %in% c(3, 4, 5, 6) & ELSA_w5_cont_rel$scfami[i] %in% 
        c(3, 4, 5, 6) & !(ELSA_w5_cont_rel$dhr2[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr3[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr4[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr5[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr6[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr7[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr8[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr9[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr10[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr11[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr12[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr13[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr14[i] %in% c(1:21) | ELSA_w5_cont_rel$dhr15[i] %in% 
        c(1:21) | ELSA_w5_cont_rel$dhr16[i] %in% c(1:21))) {
        ELSA_ds_w5$cont_rel[i] = 0
    }
}

ELSA_ds_w5$cont_rel <- car::recode(as.vector(ELSA_ds_w5$cont_rel), "NA='999'")
ELSA_ds_w5$cont_rel <- labelled(ELSA_ds_w5$cont_rel, labels = c(No = 0, Yes = 1, 
    Missing = 999, `Do not know` = 998, Refuse = 997, `Not applicable` = 996, 
    `Don't answer` = 995, `Not attempt/not done/not yet recorded` = 994, `Disable to measure` = 993, 
    Impute = 992, `CAPI/interviewer error` = 991))

2.1.5.3 Statistical description of the new harmonised variable

Sample size Missing values
10274 1078
Category
0 1
Frequency 140.00 9056.00
Percentage 1.36 88.14
Type of missing
991 992 993 994 995 996 997 998 999 NA
Frequency 0 0 0 0 0 65.00 0 0 1013.00 0
Percentage 0 0 0 0 0 0.63 0 0 9.86 0

2.1.5.4 Validation

2.1.6 Wave 6

2.1.6.1 Study-specific variable description

The study-specific variable elected to be harmonised is:

  • Name: scchdg
  • Label: On average how often do you meet up with your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfamg
  • Label: On average how often meet up with family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scchdh
  • Label: on average how often do you speak on the phone to your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scchdi
  • Label: on average how often do you write or email your children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scchdt
  • Label: How often the respondent sends or receives text messages to/from their children
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfamh
  • Label: How often the respondent speaks with other relatives on the phone
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfami
  • Label: on average how often do you write or email family members
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: scfamt
  • Label: How often the respondent sends or receives text messages to/from other relatives
  • Categories:
    • 1 = Three or more times a week
    • 2 = Once or twice a week
    • 3 = Once or twice a month
    • 4 = Every few months
    • 5 = Once or twice a year
    • 6 = Less than once a year or never
  • Missings:
    • -9 = Not answered
    • -8 = Don't know
    • -2 = Schedule Not Applicable
    • -1 = Item not applicable
  • Name: dhr1 UP TO dhr16 (dhr13 to dhr16 have NA or -1 only)
  • Label: Relationship of this person to Person 1 in the household
  • Categories:
    • 1 = Husband/Wife
    • 2 = Partner/cohabitee
    • 3 = Natural son/daughter
    • 4 = Adopted son/daughter
    • 5 = Foster son/daughter
    • 6 = Step son/daughter/child of partner
    • 7 = Son/daughter-in-law
    • 8 = Natural parent
    • 9 = Adoptive parent
    • 10 = Foster parent
    • 11 = Stepparent/parent s partner
    • 12 = Parent-in-law
    • 13 = Natural brother/sister
    • 14 = Half-brother/sister
    • 15 = Step-brother/sister
    • 16 = Adopted brother/sister
    • 17 = Foster brother/sister
    • 18 = Brother/sister-in-law
    • 19 = Grandchild
    • 20 = Grandparent
    • 21 = Other relative
    • 22 = Other non-relative
    • 96 = (THIS CODE NOT USED)
  • Missings:
    • -9 = Refusal
    • -8 = Don't Know
    • -2 = Schedule not applicable
    • -1 = Not applicable
  • Description:
SCCHDG
Sample size Missing values
10601 1813
Category
-2 1 2 3 4 5 6
Frequency 1604.00 1455.00 2569.00 1580.0 1057.00 305.00 218.00
Percentage 15.13 13.73 24.23 14.9 9.97 2.88 2.06
Type of missing
-1 -8 -9 NA
Frequency 1293.0 0 520.00 0
Percentage 12.2 0 4.91 0

SCFAMG
Sample size Missing values
10601 885
Category
-2 1 2 3 4 5 6
Frequency 1604.00 787.00 1824.00 1648.00 1801.00 1197.00 855.00
Percentage 15.13 7.42 17.21 15.55 16.99 11.29 8.07
Type of missing
-1 -8 -9 NA
Frequency 673.00 0 212 0
Percentage 6.35 0 2 0

SCCHDH
Sample size Missing values
10601 1750
Category
-2 1 2 3 4 5 6
Frequency 1604.00 2822.00 3131.00 884.00 201.0 70.00 139.00
Percentage 15.13 26.62 29.53 8.34 1.9 0.66 1.31
Type of missing
-1 -8 -9 NA
Frequency 1293.0 0 457.00 0
Percentage 12.2 0 4.31 0

SCCHDI
Sample size Missing values
10601 2468
Category
-2 1 2 3 4 5 6
Frequency 1604.00 440.00 951.00 1047.00 641.00 556.00 2894.0
Percentage 15.13 4.15 8.97 9.88 6.05 5.24 27.3
Type of missing
-1 -8 -9 NA
Frequency 1293.0 0 1175.00 0
Percentage 12.2 0 11.08 0

SCCHDT
Sample size Missing values
10601 2189
Category
-2 1 2 3 4 5 6
Frequency 1604.00 1818.00 1500.00 848 396.00 214.00 2032.00
Percentage 15.13 17.15 14.15 8 3.74 2.02 19.17
Type of missing
-1 -8 -9 NA
Frequency 1293.0 0 896.00 0
Percentage 12.2 0 8.45 0

SCFAMH
Sample size Missing values
10601 847
Category
-2 1 2 3 4 5 6
Frequency 1604.00 1398.00 2637.00 2038.00 1157.00 465.00 455.00
Percentage 15.13 13.19 24.88 19.22 10.91 4.39 4.29
Type of missing
-1 -8 -9 NA
Frequency 673.00 0 174.00 0
Percentage 6.35 0 1.64 0

SCFAMI
Sample size Missing values
10601 1629
Category
-2 1 2 3 4 5 6
Frequency 1604.00 186.00 549.00 1011.00 954 831.00 3837.00
Percentage 15.13 1.75 5.18 9.54 9 7.84 36.19
Type of missing
-1 -8 -9 NA
Frequency 673.00 0 956.00 0
Percentage 6.35 0 9.02 0

SCFAMT
Sample size Missing values
10601 1457
Category
-2 1 2 3 4 5 6
Frequency 1604.00 576.00 1005.00 1128.00 778.00 429.00 3624.00
Percentage 15.13 5.43 9.48 10.64 7.34 4.05 34.19
Type of missing
-1 -8 -9 NA
Frequency 673.00 0 784.0 0
Percentage 6.35 0 7.4 0

DHR2
Sample size Missing values
10601 6304
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 3547.00 286.0 27.00 1.00 1.00 318 6.00 1.00 3.00 5.00 22.00 1.00 14.00 4.00 61.00
Percentage 33.46 2.7 0.25 0.01 0.01 3 0.06 0.01 0.03 0.05 0.21 0.01 0.13 0.04 0.58
Type of missing
-1 -2 -8 -9 96 NA
Frequency 2035.0 0 0 0 4269.00 0
Percentage 19.2 0 0 0 40.27 0

DHR3
Sample size Missing values
10601 8343
Category
1 2 3 7 8 9 10 11 12 13 18 20 21 22
Frequency 60.00 50.00 54.00 24.00 1771.00 31.00 5.00 80.00 20.00 12.00 4.00 70.00 16.00 61.00
Percentage 0.57 0.47 0.51 0.23 16.71 0.29 0.05 0.75 0.19 0.11 0.04 0.66 0.15 0.58
Type of missing
-1 -2 -8 -9 96 NA
Frequency 8234.00 0 0 0 109.00 0
Percentage 77.67 0 0 0 1.03 0

DHR4
Sample size Missing values
10601 9142
Category
1 2 3 6 7 8 9 10 11 12 13 18 20 21 22
Frequency 19.00 14.00 29.00 1.00 10.00 1102.0 22.00 8.00 36.00 55.00 5.00 1.00 86.00 12.00 59.00
Percentage 0.18 0.13 0.27 0.01 0.09 10.4 0.21 0.08 0.34 0.52 0.05 0.01 0.81 0.11 0.56
Type of missing
-1 -2 -8 -9 96 NA
Frequency 9114.00 0 0 0 28.00 0
Percentage 85.97 0 0 0 0.26 0

DHR5
Sample size Missing values
10601 10065
Category
1 2 3 7 8 9 10 11 12 13 18 20 21 22
Frequency 7.00 9.00 12.00 11.0 340.00 4.00 4.00 16.00 24.00 5.00 1.00 66.00 8.00 29.00
Percentage 0.07 0.08 0.11 0.1 3.21 0.04 0.04 0.15 0.23 0.05 0.01 0.62 0.08 0.27
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10051.00 0 0 0 14.00 0
Percentage 94.81 0 0 0 0.13 0

DHR6
Sample size Missing values
10601 10370
Category
1 2 3 7 8 9 10 11 12 13 20 21 22
Frequency 4.00 7.00 5.00 4.00 110.00 2.00 6.00 7.00 17.00 3.00 49.00 5.00 12.00
Percentage 0.04 0.07 0.05 0.04 1.04 0.02 0.06 0.07 0.16 0.03 0.46 0.05 0.11
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10360.00 0 0 0 10.00 0
Percentage 97.73 0 0 0 0.09 0

DHR7
Sample size Missing values
10601 10524
Category
1 2 8 10 11 12 20 21 22
Frequency 1.00 2.00 21.0 4.00 2.00 5.00 27.00 3.00 12.00
Percentage 0.01 0.02 0.2 0.04 0.02 0.05 0.25 0.03 0.11
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10522.00 0 0 0 2.00 0
Percentage 99.25 0 0 0 0.02 0

DHR8
Sample size Missing values
10601 10575
Category
8 12 20 21 22
Frequency 6.00 5.00 12.00 2.00 1.00
Percentage 0.06 0.05 0.11 0.02 0.01
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10575.00 0 0 0 0 0
Percentage 99.75 0 0 0 0 0

DHR9
Sample size Missing values
10601 10589
Category
8 20 22
Frequency 3.00 8.00 1.00
Percentage 0.03 0.08 0.01
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10589.00 0 0 0 0 0
Percentage 99.89 0 0 0 0 0

DHR10
Sample size Missing values
10601 10593
Category
8 12 20
Frequency 2.00 3.00 3.00
Percentage 0.02 0.03 0.03
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10593.00 0 0 0 0 0
Percentage 99.92 0 0 0 0 0

DHR11
Sample size Missing values
10601 10595
Category
12 20
Frequency 2.00 4.00
Percentage 0.02 0.04
Type of missing
-1 -2 -8 -9 96 NA
Frequency 10595.00 0 0 0 0 0
Percentage 99.94 0 0 0 0 0

DHR12
Sample size Missing values
10601 10598
Category
12 20
Frequency 2.00 1.00
Percentage 0.02 0.01
Type of missing
-1 -8 -9 NA
Frequency 10598.00 0 0 0
Percentage 99.97 0 0 0

DHR13
Sample size Missing values
10601 10601
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10601 0 0 0
Percentage 100 0 0 0

DHR14
Sample size Missing values
10601 10601
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10601 0 0 0
Percentage 100 0 0 0

DHR15
Sample size Missing values
10601 10601
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10601 0 0 0
Percentage 100 0 0 0

DHR16
Sample size Missing values
10601 10601
Category
Frequency
Percentage
Type of missing
-1 -8 -9 NA
Frequency 10601 0 0 0
Percentage 100 0 0 0

2.1.6.2 Harmonisation algorithm

To compute the harmonize variable from the study-specific variable it has to be recoded as follows:

  • scchdg OR scfamg in {1,2,3} OR scchdh OR scchdi OR scchdt OR scfamh OR scfami OR scfamt in {1,2} OR any of DhR2,..,DhR16 in 1:21 into 1
  • scchdg AND scfamg in {4,5,6} AND scchdh AND scchdi AND scchdt AND scfamh AND scfami AND scfamt in {3,4,5,6} AND all DhR2,..,DhR16 not in 1:21 into 0
  • scchdg AND scfamg AND scchdh AND scchdi AND scchdt AND scfamh AND scfami AND scfamt in (-9,NA) AND DhR2,..,DhR16 in (-9,96,NA) into 999
  • scchdg AND scfamg AND scchdh AND scchdi AND scchdt AND scfamh AND scfami AND scfamt AND DhR2,..,DhR16 in (-1,-2) into 996
  • scchdg AND scfamg AND scchdh AND scchdi AND scchdt AND scfamh AND scfami AND scfamt AND DhR2,..,DhR16 -8 into 998

R script:

ELSA_ds_w6 <- tibble(id = ELSA_w6_cont_rel$id)

ELSA_w6_cont_rel$scchdg <- car::recode(as.vector(ELSA_w6_cont_rel$scchdg), "NA='-999'")
ELSA_w6_cont_rel$scfamg <- car::recode(as.vector(ELSA_w6_cont_rel$scfamg), "NA='-999'")

ELSA_w6_cont_rel$scchdh <- car::recode(as.vector(ELSA_w6_cont_rel$scchdh), "NA='-999'")
ELSA_w6_cont_rel$scchdi <- car::recode(as.vector(ELSA_w6_cont_rel$scchdi), "NA='-999'")
ELSA_w6_cont_rel$scchdt <- car::recode(as.vector(ELSA_w6_cont_rel$scchdt), "NA='-999'")

ELSA_w6_cont_rel$scfamh <- car::recode(as.vector(ELSA_w6_cont_rel$scfamh), "NA='-999'")
ELSA_w6_cont_rel$scfami <- car::recode(as.vector(ELSA_w6_cont_rel$scfami), "NA='-999'")
ELSA_w6_cont_rel$scfamt <- car::recode(as.vector(ELSA_w6_cont_rel$scfamt), "NA='-999'")

ELSA_w6_cont_rel$DhR2 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR2), "NA='-999'")
ELSA_w6_cont_rel$DhR3 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR3), "NA='-999'")
ELSA_w6_cont_rel$DhR4 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR4), "NA='-999'")
ELSA_w6_cont_rel$DhR5 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR5), "NA='-999'")
ELSA_w6_cont_rel$DhR6 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR6), "NA='-999'")
ELSA_w6_cont_rel$DhR7 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR7), "NA='-999'")
ELSA_w6_cont_rel$DhR8 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR8), "NA='-999'")
ELSA_w6_cont_rel$DhR9 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR9), "NA='-999'")
ELSA_w6_cont_rel$DhR10 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR10), "NA='-999'")
ELSA_w6_cont_rel$DhR11 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR11), "NA='-999'")
ELSA_w6_cont_rel$DhR12 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR12), "NA='-999'")
ELSA_w6_cont_rel$DhR13 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR13), "NA='-999'")
ELSA_w6_cont_rel$DhR14 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR14), "NA='-999'")
ELSA_w6_cont_rel$DhR15 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR15), "NA='-999'")
ELSA_w6_cont_rel$DhR16 <- car::recode(as.vector(ELSA_w6_cont_rel$DhR16), "NA='-999'")


ELSA_ds_w6$cont_rel <- c(NA)
for (i in 1:dim(ELSA_w6_cont_rel)[1]) {
    if (ELSA_w6_cont_rel$scchdg[i] %in% c(1, 2, 3) | ELSA_w6_cont_rel$scfamg[i] %in% 
        c(1, 2, 3) | ELSA_w6_cont_rel$scchdh[i] %in% c(1, 2) | ELSA_w6_cont_rel$scchdi[i] %in% 
        c(1, 2) | ELSA_w6_cont_rel$scchdt[i] %in% c(1, 2) | ELSA_w6_cont_rel$scfamh[i] %in% 
        c(1, 2) | ELSA_w6_cont_rel$scfami[i] %in% c(1, 2) | ELSA_w6_cont_rel$scfamt[i] %in% 
        c(1, 2) | ELSA_w6_cont_rel$DhR2[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR3[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR4[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR5[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR6[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR7[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR8[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR9[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR10[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR11[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR12[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR13[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR14[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR15[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR16[i] %in% c(1:21)) {
        ELSA_ds_w6$cont_rel[i] = 1
    } else if (ELSA_w6_cont_rel$scchdg[i] %in% c(-9, -999) & ELSA_w6_cont_rel$scfamg[i] %in% 
        c(-9, -999) & ELSA_w6_cont_rel$scchdh[i] %in% c(-9, -999) & ELSA_w6_cont_rel$scchdi[i] %in% 
        c(-9, -999) & ELSA_w6_cont_rel$scchdt[i] %in% c(-9, -999) & ELSA_w6_cont_rel$scfamh[i] %in% 
        c(-9, -999) & ELSA_w6_cont_rel$scfami[i] %in% c(-9, -999) & ELSA_w6_cont_rel$scfamt[i] %in% 
        c(-9, -999) & ELSA_w6_cont_rel$DhR2[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR3[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR4[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR5[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR6[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR7[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR8[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR9[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR10[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR11[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR12[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR13[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR14[i] %in% c(96, -9, -999) & ELSA_w6_cont_rel$DhR15[i] %in% 
        c(96, -9, -999) & ELSA_w6_cont_rel$DhR16[i] %in% c(96, -9, -999)) {
        ELSA_ds_w6$cont_rel[i] = 999
    } else if (ELSA_w6_cont_rel$scchdg[i] %in% c(-1, -2) & ELSA_w6_cont_rel$scfamg[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$scchdh[i] %in% c(-1, -2) & ELSA_w6_cont_rel$scchdi[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$scchdt[i] %in% c(-1, -2) & ELSA_w6_cont_rel$scfamh[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$scfami[i] %in% c(-1, -2) & ELSA_w6_cont_rel$scfamt[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR2[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR3[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR4[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR5[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR6[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR7[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR8[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR9[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR10[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR11[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR12[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR13[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR14[i] %in% c(-1, -2) & ELSA_w6_cont_rel$DhR15[i] %in% 
        c(-1, -2) & ELSA_w6_cont_rel$DhR16[i] %in% c(-1, -2)) {
        ELSA_ds_w6$cont_rel[i] = 996
    } else if (ELSA_w6_cont_rel$scchdg[i] == -8 & ELSA_w6_cont_rel$scfamg[i] == 
        -8 & ELSA_w6_cont_rel$scchdh[i] == -8 & ELSA_w6_cont_rel$scchdi[i] == 
        -8 & ELSA_w6_cont_rel$scchdt[i] == -8 & ELSA_w6_cont_rel$scfamh[i] == 
        -8 & ELSA_w6_cont_rel$scfami[i] == -8 & ELSA_w6_cont_rel$scfamt[i] == 
        -8 & ELSA_w6_cont_rel$DhR2[i] == -8 & ELSA_w6_cont_rel$DhR3[i] == -8 & 
        ELSA_w6_cont_rel$DhR4[i] == -8 & ELSA_w6_cont_rel$DhR5[i] == -8 & ELSA_w6_cont_rel$DhR6[i] == 
        -8 & ELSA_w6_cont_rel$DhR7[i] == -8 & ELSA_w6_cont_rel$DhR8[i] == -8 & 
        ELSA_w6_cont_rel$DhR9[i] == -8 & ELSA_w6_cont_rel$DhR10[i] == -8 & ELSA_w6_cont_rel$DhR11[i] == 
        -8 & ELSA_w6_cont_rel$DhR12[i] == -8 & ELSA_w6_cont_rel$DhR13[i] == 
        -8 & ELSA_w6_cont_rel$DhR14[i] == -8 & ELSA_w6_cont_rel$DhR15[i] == 
        -8 & ELSA_w6_cont_rel$DhR16[i] == -8) {
        ELSA_ds_w6$cont_rel[i] = 998
    } else if (ELSA_w6_cont_rel$scchdg[i] %in% c(4, 5, 6) & ELSA_w6_cont_rel$scfamg[i] %in% 
        c(4, 5, 6) & ELSA_w6_cont_rel$scchdh[i] %in% c(3, 4, 5, 6) & ELSA_w6_cont_rel$scchdi[i] %in% 
        c(3, 4, 5, 6) & ELSA_w6_cont_rel$scchdt[i] %in% c(3, 4, 5, 6) & ELSA_w6_cont_rel$scfamh[i] %in% 
        c(3, 4, 5, 6) & ELSA_w6_cont_rel$scfami[i] %in% c(3, 4, 5, 6) & ELSA_w6_cont_rel$scfamt[i] %in% 
        c(3, 4, 5, 6) & !(ELSA_w6_cont_rel$DhR2[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR3[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR4[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR5[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR6[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR7[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR8[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR9[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR10[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR11[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR12[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR13[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR14[i] %in% c(1:21) | ELSA_w6_cont_rel$DhR15[i] %in% 
        c(1:21) | ELSA_w6_cont_rel$DhR16[i] %in% c(1:21))) {
        ELSA_ds_w6$cont_rel[i] = 0
    }
}

ELSA_ds_w6$cont_rel <- car::recode(as.vector(ELSA_ds_w6$cont_rel), "NA='999'")
ELSA_ds_w6$cont_rel <- labelled(ELSA_ds_w6$cont_rel, labels = c(No = 0, Yes = 1, 
    Missing = 999, `Do not know` = 998, Refuse = 997, `Not applicable` = 996, 
    `Don't answer` = 995, `Not attempt/not done/not yet recorded` = 994, `Disable to measure` = 993, 
    Impute = 992, `CAPI/interviewer error` = 991))

2.1.6.3 Statistical description of the new harmonised variable

Sample size Missing values
10601 1190
Category
0 1
Frequency 125.00 9286.0
Percentage 1.18 87.6
Type of missing
991 992 993 994 995 996 997 998 999 NA
Frequency 0 0 0 0 0 358.00 0 0 832.00 0
Percentage 0 0 0 0 0 3.38 0 0 7.85 0

2.1.6.4 Validation

3 Quality estimation